package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.PlanInfo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PlanInfoMapper {
    @Insert("insert into planinfo (PNo,GNo,PINum,Price) values(#{PNo},#{GNo},#{PINum},#{price})")
    public int insertInfo(PlanInfo planInfo);
    @Select("select * from planinfo where PNo = #{PNo}")
    public List<PlanInfo> queryPlanInfoByPNo(Integer PNo);
}